IF exists(SELECT * FROM dbo.sysobjects WHERE name='eAdam_VulKlassen' AND xtype='P') 
BEGIN
	DROP PROCEDURE eAdam_VulKlassen
END
GO

CREATE procedure eAdam_VulKlassen
as
insert into eAdam_Klas(klas)
select k.klas from leraars..klasLeraars as k
left join eAdam_Klas as e
on k.klas=e.klas 
where left(k.klas,1) like '5' and e.klas is null